Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the DSN-less connection strings for ASP?

April 26, 2017ASP connection dsn-less strings

0

Posted

What are the DSN-less connection strings for ASP?

2 Answers

0

Posted

DSNless connection for MS Access: mdbfile = “/stuff/database.mdb” connstr = “Driver={Microsoft Access Driver (*.mdb)};DBQ=” & Server.MapPah( mdbfile ) & “;” DSNless connection for MySQL: Driver=[Macro error: Can’t evaluate the expression because the name “MySQL” hasn’t been defined.] ;Server=sqlc1.megasqlservers.com; DATABASE=prefix_domain_com; UID=dbm.domainname.com;PWD=password; DSNless connection for MS-SQL: DRIVER=[Macro error: Can’t compile this script because of a syntax error.] ;SERVER=mssqlc1.megasqlservers.

0

Posted

DSN-less connection for MS Access: mdbfile = “/stuff/database.mdb” connstr = “Driver={Microsoft Access Driver (*.mdb)};DBQ=” & Server.MapPah( mdbfile ) & “;” DSN-less connection for MySQL: Driver={MySQL};Server=sqlc1.megasqlservers.com; DATABASE=prefix_domain_com; UID=dbm.domainname.com;PWD=password; DSN-less connection for MS-SQL: DRIVER={SQL Server};SERVER=mssqlc1.megasqlservers.com; DATABASE= prefix_domain_com;UID=dbm_domain_com;PWD=password;