|
 |
activex_data_objects thread: HELP! sp_addlinkedserver using dsn-ODBC password protected Access 97 Db
Message #1 by "Michael Sargent" <michael.sargent@b...> on Wed, 13 Feb 2002 20:32:19
|
|
I'm trying to create a linked server on SQL 7.0 server
using a ODBC datasource to a password protected Access 97 database
- I have used the ODBC DSN successfully in DTS
- I have tried using OLE DB options for sp_addlinkedserver
- I can't seem to get syntax correct for the connectstring
I just can't seem to get it to work.
Would you provide me a successful sample?
Your help is greatly appreciated in advance!
Thanks,
Michael
Message #2 by Andy Faulkner <afaul@t...> on Wed, 13 Feb 2002 15:32:57 -0500
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1B4CD.9F6C6120
Content-Type: text/plain;
charset="iso-8859-1"
Hello, this works for me:
strODBCconnect = "ODBC;DATABASE=" & SSdatabase & ";DSN=" & SSserver &
";UID=" & SSuser_id & ";PWD=" & SSpassword
Set db = OpenDatabase("", dbDriverComplete, False, strODBCConnect)
Andy..
-----Original Message-----
From: Michael Sargent [mailto:michael.sargent@b...]
Sent: Wednesday, February 13, 2002 3:32 PM
To: ActiveX_Data_Objects
Subject: [activex_data_objects] HELP! sp_addlinkedserver using dsn-ODBC
password protected Access 97 Db
I'm trying to create a linked server on SQL 7.0 server
using a ODBC datasource to a password protected Access 97 database
- I have used the ODBC DSN successfully in DTS
- I have tried using OLE DB options for sp_addlinkedserver
- I can't seem to get syntax correct for the connectstring
I just can't seem to get it to work.
Would you provide me a successful sample?
Your help is greatly appreciated in advance!
Thanks,
Michael
$subst('Email.Unsub').
Message #3 by "Sargent, Michael J" <michael.sargent@b...> on Wed, 13 Feb 2002 15:39:53 -0500
|
|
I need to clarify(sorry)
I needed the T/SQL syntax to execute in the SQL Query Analyzer on SQL Server
7.0...
Thanks for the speedy response!
Michael
-----Original Message-----
From: Andy Faulkner [mailto:afaul@t...]
Sent: Wednesday, February 13, 2002 3:33 PM
To: ActiveX_Data_Objects
Subject: [activex_data_objects] RE: HELP! sp_addlinkedserver using dsn-ODB C
password protected Access 97 Db
Hello, this works for me:
strODBCconnect = "ODBC;DATABASE=" & SSdatabase & ";DSN=" & SSserver &
";UID=" & SSuser_id & ";PWD=" & SSpassword
Set db = OpenDatabase("", dbDriverComplete, False, strODBCConnect)
Andy..
-----Original Message-----
From: Michael Sargent [ mailto:michael.sargent@b...
<mailto:michael.sargent@b...> ]
Sent: Wednesday, February 13, 2002 3:32 PM
To: ActiveX_Data_Objects
Subject: [activex_data_objects] HELP! sp_addlinkedserver using dsn-ODBC
password protected Access 97 Db
I'm trying to create a linked server on SQL 7.0 server
using a ODBC datasource to a password protected Access 97 database
- I have used the ODBC DSN successfully in DTS
- I have tried using OLE DB options for sp_addlinkedserver
- I can't seem to get syntax correct for the connectstring
I just can't seem to get it to work.
Would you provide me a successful sample?
Your help is greatly appreciated in advance!
Thanks,
Michael
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
$subst('Email.Unsub').
$subst('Email.Unsub').
|
|
|
View Cart
