|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Access97, Sql Server, Win 2000
I am creating a connection FROM an Acces97 FrontEnd TO an SQL Server
database as follows
NewTableDef.SourceTableName = "xxx"
'ODBC Driver is called JayRemote
ConnStr = "ODBC;DRIVER=SQL Server;SERVER=JayRemote_v2;_
APP=Microsoft® Access;DATABASE=cnettestsqldb;_
Network=DBMSSOCN;Address=***.***.***.225,1433"
'Uid and PWD are are variables set to appropriate values
ConnStr = ConnStr & ";UID=" & Uid & ";PWD=" & Pwd
NewTableDef.Connect = ConnStr
cdb.TableDefs.Append NewTableDef
?? is there a TimeOut parameter I can include in ConnStr ??
Jim Bunton
|
|
|