Solved

Cannot access SQL Server after Install Shield Installation

Posted on 1998-10-30
5
700 Views
Last Modified: 2006-11-17
I have developed a client-server application which uses VB as the front end and SQL Server as the back end.  I built an install using install shield.  When i run the app on the target machine, i receive the error "[Microsoft][ODBC Driver Manager]Data Source name not found and no default driver specified".  I am not using a DSN to connect to my data source, i am sending a connect string at run time.  I am using RDO in VB5.0.
0
Comment
Question by:emidiod
5 Comments
 
LVL 9

Expert Comment

by:david_levine
ID: 1090934
Isn't the connect string just specifying the ODBC connection to use?

Does your machine have an ODBC connection already defined? If so, try adding by hand, the connection to the other machine. If that fixes the issue, you will need to do this in the setup program.
0
 

Author Comment

by:emidiod
ID: 1090935
I am not using a DSN, I am sending the connection info at run-time as shown below:

Set mObjRDOConnection = mObjRDOEnvironment.OpenConnection("", rdDriverNoPrompt, False, msConnectString)

Where msConnectString is
 "Driver={SQL Server};SERVER=ServerName;DATABASE=DatabaseName;
  UID=UserID;PWD=Password;DSN="

Notice that the DSN is blank.  

0
 
LVL 9

Expert Comment

by:david_levine
ID: 1090936
Does the machine have the MS SQL Client software installed? Can it do a database ping of your target db? Can it log-in using the id / password / database / server you have specified?
0
 
LVL 2

Expert Comment

by:mkmccreary
ID: 1090937
Try removing the DSN parameter at the end of the connect string.  It might work on your machine because you have the database you are connecting to set as the default datasource.  Right now your connect string is trying to connect to a DSN with a empty name.

Good Luck,
Martin
0
 
LVL 3

Accepted Solution

by:
TheAnswerMan earned 100 total points
ID: 1090938
Your DSN is fine.. you are using a DSN-less connection.
can you connect to your database using those parameter in any other fashion?   you can try creating a DSN on your client machine an make sure you use those specific parameters and nothin more.   then see if you can link an access table to your SQL Server.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Alter table 4 23
grouping logic 6 46
Sql query 107 25
SQL 2008 R2 calc date formula 3 25
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now