forum.vdsworld.com Forum Index forum.vdsworld.com
Visit VDSWORLD.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


VDSDB question

 
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> Product Support
View previous topic :: View next topic  
Author Message
marty
Professional Member
Professional Member


Joined: 10 May 2001
Posts: 789

PostPosted: Thu Jul 17, 2003 2:42 pm    Post subject: VDSDB question Reply with quote

Hi,

I'm trying to connect to an already created File DSN or System DSN using the proper UID and PWD and I'm always getting the error code 1004.

Code Im using:
DB CONNECT,TEST DB,QUALITY, TEST

Its a SQL Server DB, not local.

Im a bit confused on out to connect. Thanks.
Back to top
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
Tommy
Admin Team


Joined: 16 Nov 2002
Posts: 746
Location: The Netherlands

PostPosted: Thu Jul 17, 2003 2:48 pm    Post subject: Reply with quote

I'm not sure what you're doing wrong for now, but could you please try executing something
similar to this?

Code:

OPTION ERRORTRAP,ERROR
DB CONNECT,TEST DB,QUALITY, TEST
EXIT
:ERROR
  INFO @DB(ERROR)
  STOP
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Rubes_sw
Valued Contributor
Valued Contributor


Joined: 11 Jun 2001
Posts: 625
Location: Northern Ireland

PostPosted: Thu Jul 17, 2003 2:49 pm    Post subject: Reply with quote

Marty, If its a remote sql database you would have to use,

tommys vdsmysql.dll

mysql login,@dlgtext(eHostname),@dlgtext(eUsername),@dlgtext(ePassword),@dlgtext(ePort)

It's not part of vdsdll.dll and i don't think tommy has the vds5 fix applied to it yet.

Nathan
Back to top
View user's profile Send private message Send e-mail Visit poster's website
marty
Professional Member
Professional Member


Joined: 10 May 2001
Posts: 789

PostPosted: Thu Jul 17, 2003 3:40 pm    Post subject: Reply with quote

Code:
directory change,@path(%0)
external vdsdb.dll
OPTION ERRORTRAP,ERROR
rem create database alias
db setup,"SQL Server",DSN=QATEST,UID=TESTQA,PWD=QA,DataDirectory=,DBQ=SQL01
rem establish database connection
db connect,QATEST,TESTQA,QA

exit
:ERROR
INFO @DB(ERROR)
STOP


Im getting the error : 4201545|

And yes Its not a local DB on my machine.. Should I still use MySql? Its a Microsoft Database server.
Back to top
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
Tommy
Admin Team


Joined: 16 Nov 2002
Posts: 746
Location: The Netherlands

PostPosted: Sun Jul 20, 2003 10:59 pm    Post subject: Reply with quote

Marty, of course this is entirely unrelated to MySQL (or the VDSMYSQL DLL), as this
is the Microsoft SQL Server and not a MySQL database server.

The error description you gave me isn't likely to going to help me, as somehow no
error description is given....
Back to top
View user's profile Send private message Send e-mail Visit poster's website
marty
Professional Member
Professional Member


Joined: 10 May 2001
Posts: 789

PostPosted: Mon Jul 21, 2003 11:08 am    Post subject: Reply with quote

Sorry Tommy, but thats what the DLL is returning me.. Number without any Description.

I found other issues with VDSDB 2.0 vs VDSDB 2.1.. Will let you know soon.. BTW Have a nice vacation! Very Happy
Back to top
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> Product Support All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

Twitter@vdsworld       RSS

Powered by phpBB © 2001, 2005 phpBB Group