ODBC Connection String
-
Hello all, I am trying my first ASP.NET database connectivity coding. My web host lets me use ODBC and has given me a Data Source Name. (DNS). I am trying to connect to my Access File say webdata.mdb. I cannot seem to make a connection with the wizard so I would like to write a connecton string my self. It is my understanding that non-SQL server connections require that the connection string provide the provider. I would like to use Microsoft OLE DB Provider of ODBC drivers. How do I specify this in a connecton string? Do I need to specify the DNS and if so how? Any help would be greatl appreciated.
-
Hello all, I am trying my first ASP.NET database connectivity coding. My web host lets me use ODBC and has given me a Data Source Name. (DNS). I am trying to connect to my Access File say webdata.mdb. I cannot seem to make a connection with the wizard so I would like to write a connecton string my self. It is my understanding that non-SQL server connections require that the connection string provide the provider. I would like to use Microsoft OLE DB Provider of ODBC drivers. How do I specify this in a connecton string? Do I need to specify the DNS and if so how? Any help would be greatl appreciated.
Data Source AND DSN are the name of your DSN in your Webhost Provider=MSDASQL.1;Persist Security Info=False;Data Source=TEST;Extended Properties="DSN=TEST;DBQ=C:\TEST.MDB;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;" I hope this helps you. Vanclei Matheus Brazil MSN Msgr - vmatheus@msn.com