PC Review


Reply
Thread Tools Rate Thread

MSDE Connection

 
 
=?Utf-8?B?R2xlbm4gU3VnZ3M=?=
Guest
Posts: n/a
 
      9th Oct 2004
Can anyone tell me how to go about setting up the MSDE ODBC connection
required to run the VB sample at
http://msdn.microsoft.com/vstudio/do.../condwnld.aspx ?
Should this be done through an application such as MS Access?
Thanks
--
Glenn
 
Reply With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      9th Oct 2004
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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Glenn Suggs" <(E-Mail Removed)> wrote in message
news:51EAF7A4-39C2-4FBE-AA90-(E-Mail Removed)...
> Can anyone tell me how to go about setting up the MSDE ODBC connection
> required to run the VB sample at
> http://msdn.microsoft.com/vstudio/do.../condwnld.aspx ?
> Should this be done through an application such as MS Access?
> Thanks
> --
> Glenn



 
Reply With Quote
 
 
 
 
=?Utf-8?B?R2xlbm4gU3VnZ3M=?=
Guest
Posts: n/a
 
      9th Oct 2004
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

"Douglas J. Steele" wrote:

> 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.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Glenn Suggs" <(E-Mail Removed)> wrote in message
> news:51EAF7A4-39C2-4FBE-AA90-(E-Mail Removed)...
> > Can anyone tell me how to go about setting up the MSDE ODBC connection
> > required to run the VB sample at
> > http://msdn.microsoft.com/vstudio/do.../condwnld.aspx ?
> > Should this be done through an application such as MS Access?
> > Thanks
> > --
> > Glenn

>
>
>

 
Reply With Quote
 
Douglas J. Steele
Guest
Posts: n/a
 
      9th Oct 2004
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)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Glenn Suggs" <(E-Mail Removed)> wrote in message
news:AD3D6BB6-DD91-4778-8C16-(E-Mail Removed)...
> 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
>
> "Douglas J. Steele" wrote:
>
> > 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.
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no e-mails, please!)
> >
> >
> >
> > "Glenn Suggs" <(E-Mail Removed)> wrote in message
> > news:51EAF7A4-39C2-4FBE-AA90-(E-Mail Removed)...
> > > Can anyone tell me how to go about setting up the MSDE ODBC connection
> > > required to run the VB sample at
> > > http://msdn.microsoft.com/vstudio/do.../condwnld.aspx

?
> > > Should this be done through an application such as MS Access?
> > > Thanks
> > > --
> > > Glenn

> >
> >
> >



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove connection to MSDE 2000 John Blair Microsoft Dot NET 2 18th Feb 2005 06:02 PM
Specify in connection string where MSDE data is stored Amy Microsoft ADO .NET 4 11th Nov 2004 12:21 AM
Problem with disable msde connection pool Mandy Microsoft ADO .NET 3 24th Sep 2004 07:09 PM
ACCESS ADP/MSDE Connection Failure Tom P. Microsoft Access ADP SQL Server 5 17th Sep 2003 07:59 PM
ACCESS ADP/MSDE Connection Failure Tom P. Microsoft Access ADP SQL Server 0 16th Sep 2003 04:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:47 PM.