Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mamatha
Posting Yak Master
102 Posts |
 Posted - 2005-04-05 : 03:51:34
|
| HiI have a code in ASP to import tables from SQL server Access.The code is like the following: set lcnn = Server.CreateObject("ADODB.Connection") lcnn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ _ "Dbq=db1.mdb;" & _ "DefaultDir=d:\;" & _ "Uid=Admin;Pwd=;" lcnn.execute "SELECT * INTO " & _ "[tblpath] " & _ "FROM " & _ "[ODBC;Driver=SQL Server; " & _ "SERVER=sreeni;DATABASE=parameter;" & _ "UID=sa;PWD=thanks;]." & _ "[tbl_path];" But when i execute this code,i got the error: "[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL Server sreeni' failed "Why this error occurs?Please give me solution.If i remove "ODBC" word near Driver=SQL Server then it gives error like: "Colud not find installable ISAM".Please give me any solution to work this code.ThanksMamathaMamatha |
|
|
|
|
|
How this code will work?