VB & Database, [ODBC Driver Manager] Data source name not found and no default driver specified

[ODBC Driver Manager] Data source name not found and no default driver specified

Author	Message
Adam W. Saxto #1 / 3	[ODBC Driver Manager] Data source name not found and no default driver specified I have a VB 6 (SP5) Application connecting to a SQL Server 7 Database that is housed on a separate machine. The machine that is hosting the application has MDAC 2.7 SP1 installed and is a Windows 2000 Server. When running the application i'm getting an error message: ID: -2147467259 Description: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified On my development machine it works fine but it's going to a SQL Server 2000 database... Here is the connection strings i've tried on the the hosting machine are: "Provider=MSDASQL;Driver=SQL Server;Server=ServerName;UID=User;PWD=Password;Database=DatabaseName" And (this is the one i use on my WinXP machine connection to SQL 2k) "Provider=SQLOLEDB.1;Password=Password;Persist Security Info=True;User ID=User;Initial Catalog=DatabaseName;Data Source=ServerName" I haven't been able to find anything of help out on the internet... and i'm completely baffeled as to why this error is happening... Any help is greatly appreciated! Thanks, Adam
Mon, 24 Oct 2005 07:24:03 GMT

Jason Keat #2 / 3	[ODBC Driver Manager] Data source name not found and no default driver specified Quote: > I have a VB 6 (SP5) Application connecting to a SQL Server 7 Database > that is housed on a separate machine. > The machine that is hosting the application has MDAC 2.7 SP1 > installed and is a Windows 2000 Server. > When running the application i'm getting an error message: > ID: -2147467259 > Description: [Microsoft][ODBC Driver Manager] Data source name not > found and no default driver specified > On my development machine it works fine but it's going to a SQL > Server 2000 database... > Here is the connection strings i've tried on the the hosting machine > are: > "Provider=MSDASQL;Driver=SQL > Server;Server=ServerName;UID=User;PWD=Password;Database=DatabaseName" > And (this is the one i use on my WinXP machine connection to SQL 2k) > "Provider=SQLOLEDB.1;Password=Password;Persist Security Info=True;User > ID=User;Initial Catalog=DatabaseName;Data Source=ServerName" > I haven't been able to find anything of help out on the internet... > and i'm completely baffeled as to why this error is happening... > Any help is greatly appreciated! > Thanks, > Adam http://www.able-consulting.com/ADO_Conn.htm http://www.connectionstrings.com/
Mon, 24 Oct 2005 22:08:26 GMT

Vladimi #3 / 3	[ODBC Driver Manager] Data source name not found and no default driver specified Try using UDL files Quote: ----- Original Message ----- Newsgroups: microsoft.public.vb.database Sent: Thursday, May 08, 2003 5:24 AM Subject: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified > I have a VB 6 (SP5) Application connecting to a SQL Server 7 Database that > is housed on a separate machine. > The machine that is hosting the application has MDAC 2.7 SP1 installed and > is a Windows 2000 Server. > When running the application i'm getting an error message: > ID: -2147467259 > Description: [Microsoft][ODBC Driver Manager] Data source name not found and > no default driver specified > On my development machine it works fine but it's going to a SQL Server 2000 > database... > Here is the connection strings i've tried on the the hosting machine are: > "Provider=MSDASQL;Driver=SQL > Server;Server=ServerName;UID=User;PWD=Password;Database=DatabaseName" > And (this is the one i use on my WinXP machine connection to SQL 2k) > "Provider=SQLOLEDB.1;Password=Password;Persist Security Info=True;User > ID=User;Initial Catalog=DatabaseName;Data Source=ServerName" > I haven't been able to find anything of help out on the internet... and i'm > completely baffeled as to why this error is happening... > Any help is greatly appreciated! > Thanks, > Adam
Tue, 25 Oct 2005 00:25:36 GMT

Page 1 of 1

[ 3 post ]