473,386 Members | 1,883 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Need to send a directive to linked database

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
2 2036
"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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: David Gray | last post by:
Hello all, Having problems connecting to an Oracle 9i database from within SQL/Server 2000 using the Security/Linked Servers feature. Server1 (SQL/Server) ----------- Windows Server 2003,...
15
by: drdoubt | last post by:
using namespace std In my C++ program, even after applying , I need to use the std namespace with the scope resolution operator, like, std::cout, std::vector. This I found a little bit...
13
by: RainBow | last post by:
Hi everyone, (Very Sorry, if this is the wrong group in which I am posting this query). Code snippet: //C library typedef int (*PFunc)(int* aArg); void call_c_foo(PFunc aPtrtoFunc) {
8
by: Adam Greifer | last post by:
Hi! I'm a newbie at DB2 but have 13 years of SQL Server. I need to convert over 100 SQL Server procs to DB2. I haven't had much luck with the IBM Integration Toolkit and want to avoid ER/win...
2
by: Robert McGregor | last post by:
Hi all, I've got a Front End / Back End database that was working just fine. One day i opened the FE to find that if I tried to open one of the linked tables from the database window, nothing...
5
by: deko | last post by:
How to run action query against linked table? I have an Access 2003 mdb with an Excel 2003 Workbook as a linked table. When I attempt to run an action query against the linked table I get this...
20
by: mike | last post by:
I help manage a large web site, one that has over 600 html pages... It's a reference site for ham radio folks and as an example, one page indexes over 1.8 gb of on-line PDF documents. The site...
4
by: mimi | last post by:
The programmer indicates to the compiler that a function is written in a different programming language using a linkage directives.It is intuitive that extern "SomeLanguage" is used to declare...
4
by: alvinstraight38 | last post by:
Hey guys, I am trying to import data from an Excel spreadsheet into my SQL database. I am running SQL 2005. I following Microsoft's instructions for creating a linked server, and it appeared...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.