6 replies to this topic

[Ubuntu_monster]

Hi every one from My country : good morning .....


Somebody help me ..

How can I connect visual vasic 2005 with Sql server 2005 manually "not with wizard" ,

What is The Correct String for The Connection statement and i need The following statements :

1 - The Command statement.
2 - The Adapter Statement .
3 - The Reader statement


-- When I write the code to connect with data base i face the Runtime error :
"InvalidOperationException"....


Some body help ....

[WingedPanther]

It will depend: are you doing an ADO connection, an ODBC connection, or something else?

[Xav]

He said SQL Server - are there more than one type of connection for that? Forgive my ignorance, I haven't done any database work.

[WingedPanther]

There are at least three ways to connect that I know of: ADO, ODBC, and direct (basically a telnet to the SQL Server port and issue commands based on the API). Each connection type requires different configuration methods.

[Ubuntu_monster]

WingedPanther said:

There are at least three ways to connect that I know of: ADO, ODBC, and direct

Dear WingedPanther :

I need to connect it with ADO

[WingedPanther]

Your connection string will resemble:
"Driver={SQL Server};Server=MyServer;Database=MyDatabase;Uid=MyLogin;Pwd=MyPassword;"

[Xav]

Unless you haven't set up any user name and password credentials...