MSDE Connection

  • Thread starter Thread starter Guest
  • Start date Start date
I can't think of any reason why you'd need to use Access in conjunction with
that sample, although I'll admit I haven't bothered looking closely at it.

Have you installed MSDE? Is there any documentation that accompanies the
sample code? I would think you'd probably need to set up a DSN with a
specific name that the code uses. Failing that, there may be a Connection
String specified in the code, and you may have to change something there to
point to a specific database.
 
Hello Doug,

Yes, I've installed MSDE and the readme.txt that came with the sample says
it assumes that I have set up an ODBC data source called NorthwindMSDE and am
connecting to a database called NorthwindCS. The windows XP help screens say
you can set up the DSN through any app such as Access, FoxPro, etc. I pulled
up the database in Access and it asked if I wanted to install the db to SQL
Server. (I'm a VB/Access programmer trying to get a handle on working with
SQL Server) Anyway, the VB sample still doesn't work and I don't see
anything in the program's connection string that points to a particular
location. I guess I am just not sure what to change in the code.
Thanks again,
Glenn
 
DSN are usually set up through the Control Panel.

Performance and Maintenance | Administrative Tools | Data Sources (ODBC) if
you're using the Category View (or strictly Data Sources (ODBC) if you're in
the "Classic" View)
 
Back
Top