Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link SQL Related Articles: Connecting to a remote MSSQL databaes 2004-03-21 -- Mark Riffey Newsgroups: sv.clarion.documentation
> It would be nice to have an example of how to connect to a remote database.
> Connecting to a SQL server on a local machine or LAN is pretty
> straightforward, but if I want my users to be able to connect to a MS SQL
> server running on machine SOLACE-2000 at IP address 81.133.147.54, what
> would be the connection string
Its slightly different than MySQL, but not much. The key is to use the IP
address, not the machine name, otherwise the string really doesnt change
for MSSQL. And open port 1433, if necessary.
Example for MSSQL:
Provider=SQLOLEDB.1;Password=yourpassword;Persist Security Info=True;User
ID=yourusername;Initial Catalog=yourcatalog;server=81.133.147.54
Mark
Today is December 3, 2024, 11:53 am This article has been viewed 35261 times. Google search has resulted in 72 hits on this article since January 25, 2004.
|
|