Buropro-Citation
asked on
Connecting to online SQL server database via Delphi application
Hi everyone, I'm trying to connect to a SQL database located on my web server using my Delphi application. Every of my customers using this application will have to be able to acces this database from their company without them having to configure something on their computers.
I'm not sure how to do this and would need an expert help on this matter, currently I'm using this connection string for local databases but it doesn't seem to work when I use IP address for the server.
ConnectString := 'Provider=SQLOLEDB.1;Integ rated Security=SSPI;Persist Security Info=False;Data Source=' + vServer + ';Initial Catalog=' + vTable + ';'
I'm not sure how to do this and would need an expert help on this matter, currently I'm using this connection string for local databases but it doesn't seem to work when I use IP address for the server.
ConnectString := 'Provider=SQLOLEDB.1;Integ
One follow up - you will probably not be able to use Integrated security, as your users would not likely have local windows or domain accounts on your web server. You'll need to use individual user names & passwords.
DataConnection = "Provider=SQLOLEDB.1;Initi al Catalog=;Data Source=;UID=;PWD=;Connect Timeout=15"
DataConnection = "Provider=SQLOLEDB.1;Initi
ASKER
Removing the SSPI helped, I'm now able to see a log event in the sql server management studio. Problem I'm now getting an error, I'm using UID=SA;PWD=SA; but I'm getting a 18456 error (gravity 14, state 8) which is clearly a password error even though SA is the right password.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In the above statement, 'vTable' should be the Database name, not the table name, correct?