Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Programming > Connection String

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Connection String

Reply to Message Icon

Name: henry_joshua
Date: April 15, 2004 at 03:02:33 Pacific
OS: win 98
CPU/Ram: P-4/128
Comment:

Dear Friends,
Pls Help. I want to write an sql statement which makes use of 2 tables in 2 different databases. How do I write the connection string.

Pls Help

Thanx
Mala



Sponsored Link
Ads by Google

Response Number 1
Name: princedan
Date: April 15, 2004 at 09:19:10 Pacific
Reply:

set 2 different connecction to database.. and declare 2 diff statement .. it should do nicely.. remember to close the connection and statement. hope it helps..


0

Response Number 2
Name: henry_joshua
Date: April 16, 2004 at 02:52:41 Pacific
Reply:

Dear Daniel,
Thanx for ur reply. But I have got only one Sql Statement, which makes use of 2 tables in 2 different databases. Suppose we have got connection1 and connection2 , but in the statement we either give

rs_tmp.Open sql1, connection1, adOpenKeyset, adLockOptimistic

or
rs_tmp.Open sql1, connection2, adOpenKeyset, adLockOptimistic

i want to use 2 tables in one sql statement.

Thanx for ur reply.

Pls help me.

Thanx

Mala


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links
Ads by Google


Results for: Connection String
VB6 Mysql remote connection string www.computing.net/answers/programming/vb6-mysql-remote-connection-string/13709.html

VB6 FTP Access connection string www.computing.net/answers/programming/vb6-ftp-access-connection-string/13697.html

Password in connection string on VB www.computing.net/answers/programming/password-in-connection-string-on-vb/484.html