By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,028 Members | 1,092 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,028 IT Pros & Developers. It's quick & easy.

Need to send a directive to linked database

P: n/a
I need to insert records into a Sybase database via a linked table.

I have a valid, tested DSN ODBC connection to the Sybase database
named 'SBA9link'. I also have created a link to a table in the Sybase
database that I need to insert into named 'dbo_External_Data'. This is
the only means that I have to communicate with the Sybase database.

Before I can do inserts into this table I must send the Sybase
database an authentication string: 'SET TEMPORARY OPTION
CONNECTION_AUTHENTICATION xxxxxxx'.

I don't need to do anything fancy, just a simple Insert Query would be
fine so long as I can get the data into the Sybase 'External_Data'
table. Without sending that authentication string, I'm not allowed to
do inserts.

I don't have any idea how to send this authentication string. It can't
be done as a parameter to the Sybase ODBC driver, I've tried. I would
appreciate any and all help with this.

Thanks.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"fumanchu" <le******@verizon.net> wrote in message
news:n3********************************@4ax.com...
I need to insert records into a Sybase database via a linked table.

I have a valid, tested DSN ODBC connection to the Sybase database
named 'SBA9link'. I also have created a link to a table in the Sybase
database that I need to insert into named 'dbo_External_Data'. This is
the only means that I have to communicate with the Sybase database.

Before I can do inserts into this table I must send the Sybase
database an authentication string: 'SET TEMPORARY OPTION
CONNECTION_AUTHENTICATION xxxxxxx'.

I don't need to do anything fancy, just a simple Insert Query would be
fine so long as I can get the data into the Sybase 'External_Data'
table. Without sending that authentication string, I'm not allowed to
do inserts.

I don't have any idea how to send this authentication string. It can't
be done as a parameter to the Sybase ODBC driver, I've tried. I would
appreciate any and all help with this.

Thanks.


Have you looked at Pass-Through queries. This is when Access says "I don't
know or care what you write to the server - I'll just pass it on and let the
database server handle it"
Nov 13 '05 #2

P: n/a
Great tip! Thanks!

I'd forgotten all about pass through, hadn't used it in years.

Passed the authentication string with no problem.

On Mon, 19 Sep 2005 09:59:28 +0000 (UTC), "Brian Wilson"
<bw*****@ease.co.uk> wrote:
"fumanchu" <le******@verizon.net> wrote in message
news:n3********************************@4ax.com.. .
I need to insert records into a Sybase database via a linked table.

I have a valid, tested DSN ODBC connection to the Sybase database
named 'SBA9link'. I also have created a link to a table in the Sybase
database that I need to insert into named 'dbo_External_Data'. This is
the only means that I have to communicate with the Sybase database.

Before I can do inserts into this table I must send the Sybase
database an authentication string: 'SET TEMPORARY OPTION
CONNECTION_AUTHENTICATION xxxxxxx'.

I don't need to do anything fancy, just a simple Insert Query would be
fine so long as I can get the data into the Sybase 'External_Data'
table. Without sending that authentication string, I'm not allowed to
do inserts.

I don't have any idea how to send this authentication string. It can't
be done as a parameter to the Sybase ODBC driver, I've tried. I would
appreciate any and all help with this.

Thanks.


Have you looked at Pass-Through queries. This is when Access says "I don't
know or care what you write to the server - I'll just pass it on and let the
database server handle it"

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.