Link to home
Start Free TrialLog in
Avatar of johnmaserati
johnmaserati

asked on

VB linking to SQL db

I have an IP address to an SQL db and all the correct details, i can prove this by setting up a system dsn and all is well.

Quesiton:  i need to distribute this app to 150 people and therefore need to get the connection setup either as a system dsn or as a clever work around.  The SQL server is only addressable as an IP address not by name.  If as a DSN how do i include this as part of the distribution package?

thanks

john
Avatar of Richie_Simonetti
Richie_Simonetti
Flag of Argentina image

You could include any file with P&D Wizard.
Avatar of dancebert
dancebert

I think I have a solution if the answer to both the following questions is true.

Is the IP address of the server part of the connection string?

Do both workstation and server operating sytsems support Com+?  (I think that's XP and 2000, but I'm not sure)
i don't know how did you set your DSN, but if you need to translate ip address to host name, it could be done.
ASKER CERTIFIED SOLUTION
Avatar of selim007
selim007

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
P.S. the server name can be an IP address
I think I have a solution if the answer to both the following questions is true.

Is the IP address of the server part of the connection string?

Do both workstation and server operating sytsems support Com+?  (I think that's XP and 2000, but I'm not sure)
Avatar of johnmaserati

ASKER

Sorry i should have made one thing clear.

I am using the data link which is part of the VB ide.  The data link doesn't appear to allow me to dig around and manually set the connection string (could be wrong) so i can't use
****
strConnectionString = "Driver={SQL Server};Server=servername;UID=username;PWD=password;Database=database_name;"

I did this with the last VB project but i wasn't using the built in data controls the dsr etc..

Adding a file, what file?  does the P&D process capture the details of my DSN and add that to the package?

Com: I don't know and probably won't get a reliable answer as to whether the server will be running COM.


i maybe being obtuse here or having brain fade
thanks,

you're right.  pity i can't use this with the datalink in vb, or is the datalink to be avoided?