I am trying to connect to a SQL Server 2005 DB from my VB application from Visual Studio 2005. In the properties windows, when I try to mention the db name, its asking for sdf file and all we got is a mdf and a ldf file. How do I connect to the DB?
Thank you.
Regards,
Abhishek
You must create an ODBC connection to your SQL database in the Windows Control Panel. Than you can call your ODBC connection via Visual Studio 2005. You can also create a DSN in Visual Studio 2005 and reference in that way. You will not be able to connect to an MDF but instead you have to connect to the SQL Server Service. Of course the username you use to connect must have access that will be created on the SQL server.
You have to creat a table in the SQL server db then you can
a) use some windows host script or vb to read your data and insert into the db..
b)you can also use the acess:
217 views
Usually answered in minutes!
Is this for a data grid or are you just going to use ADO.NET?
×