SQL Connection

[rstum2005]

Connecting to SQL Server 2000.

Any tips on how to do this?

 

[2ffat]

I use ADO. Which version of Builder are you using?


James P. Cottingham
-----------------------------------------
^{I'm number 1,229!
I'm number 1,229!}

 

[rstum2005]

Im using version 6.0

 

[2ffat]

Good. Is it the personal, Professional, or Developer version? Do you have the dbGo or ADO components? I know these come standard in the Developer version but I don't know about the Pro version.



James P. Cottingham
-----------------------------------------
^{I'm number 1,229!
I'm number 1,229!}

 

[rstum2005]

I dont quite remember. Im not at my desktop but I know for sure it as ado components. Whenever I try to connect to a database it asks for username and password and it does not accept the windows un&pass. Im quite lost, thanks for you help.

 

[2ffat]

You will need to set up the ADO connection string for your ADO component(s). I can also show you how to set up a connection through Windows ADO API. It's an undocumented call. When you are ready, let me know. It's not hard once you understand it.

James P. Cottingham
-----------------------------------------
^{I'm number 1,229!
I'm number 1,229!}

 

[rstum2005]

Ok thanks. Ill read into it and get back with you with some more questions.

Ron

 

[Ginka]

It is very easy, just copy and paste this


ServerName is an AnsiString (loaded externaly), leave it like that, because that way you can change the serverName
without changing the code

Connection->ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=YourDataBaseName;Data Source=" + ServerName;

 

[rstum2005]

I got it working now thanks.