setup a ODBC text file driver
what do I have to do in SB5 to setup an ODBC connection with a file called label.txt that resides on the PC in c:\lables directory. On the ODBC tab I clicked the txt odbc source but don't know how to tell it which file and where. Or do you have to set that up on every machine via the ODBC DSN setup. Thanks.
Re: setup a ODBC text file driver
Hello,
Please consult your ODBC documentation. SB5 provides an interface to ODBC. But you have to enter the exact ODBC parameters. There are hundreds of different ODBC drivers on the market and each and every comes with it's own specific syntax.
Do you have such a ODBC manual available?
Re: setup a ODBC text file driver
I am trying to setup a TEXT driver.... I found how to configure but don't know the exact parameter for ODBC. I don't have a manual, do you know where I can download one or is it with Windows XP? thank you.
Quote:
Originally Posted by linder
Hello,
Please consult your ODBC documentation. SB5 provides an interface to ODBC. But you have to enter the exact ODBC parameters. There are hundreds of different ODBC drivers on the market and each and every comes with it's own specific syntax.
Do you have such a ODBC manual available?
Re: setup a ODBC text file driver
Hello,
Hmm, TEXT driver? Do you know the vendor of this ODBC driver? The manual does not come with Windows XP or any other OS. The developer of the driver should have such a manual available.
BTW, the following is a demo to add a Adaptive Server Anywhere 9.0 DSN:
Data Source Name: TestConn
Driver Name: Adaptive Server Anywhere 9.0
Attributes:
AutoStart=NO
AutoStop=NO
CommLinks=SharedMemory,TCPIP{}
Compress=NO
Debug=NO
DisableMultiRowFetch=NO
Driver=C:\Program Files\Sybase\SQL Anywhere 9\win32\dbodbc9.dll
EngineName=Office
Integrated=NO
PWD=ab081261
UID=dba
HTH,
Re: setup a ODBC text file driver
Hi Friedrich,
Microsoft makes the Text driver..... Heres what I got so far in the script
[ Modify System ]
Create Folder "c:\label"
Install ODBC Driver "Microsoft Text Driver (*.txt; *.csv)" (Always Install)
Configure ODBC Data Source "Label"
then within the Install ODBC it put ....
Driver=%SYS32DIR%\odbcjt32.dll
Setup=%SYS32DIR%\odtext32.dll
APILevel=1
ConnectFunctions=YYN
DriverODBCVer=02.50
FileUsage=1
FileExtns=*.,*.asc,*.csv,*.tab,*.txt,*.csv
SQLLevel=0
then in the Configure Data Source the name is LABEL but have to point label.txt to the directory in C:\LABEL.
which I put DataDirectory=C:\label in the attributes.
Have to test it out and see if it works. thanks for your help.
Quote:
Originally Posted by linder
Hello,
Hmm, TEXT driver? Do you know the vendor of this ODBC driver? The manual does not come with Windows XP or any other OS. The developer of the driver should have such a manual available.
BTW, the following is a demo to add a Adaptive Server Anywhere 9.0 DSN:
Data Source Name: TestConn
Driver Name: Adaptive Server Anywhere 9.0
Attributes:
AutoStart=NO
AutoStop=NO
CommLinks=SharedMemory,TCPIP{}
Compress=NO
Debug=NO
DisableMultiRowFetch=NO
Driver=C:\Program Files\Sybase\SQL Anywhere 9\win32\dbodbc9.dll
EngineName=Office
Integrated=NO
PWD=ab081261
UID=dba
HTH,
Re: setup a ODBC text file driver
Looks good!
You are welcome.
Re: setup a ODBC text file driver
Hi Friedrich,
Ok getting closer.... now I am trying an install on a new PC and this is the error I get. What does this mean?
"the setup routines for the Microsoft Text Driver ODBC driver could not be found. Please reinstall the driver.
Any suggestions? thanks again.
Quote:
Originally Posted by linder
Looks good!
You are welcome.
Re: setup a ODBC text file driver
Hello,
Because this problem is not related to the installation system (it's an Microsoft ODBC driver issue) I don’t know what it means, and I can only guess that it’s some kind dependency file (mfc42.dll???) problem.
See: http://dbforums.com/showthread.php?threadid=504872
Does this help?
Re: setup a ODBC text file driver
No help at all.... I did try to update that DLL with a newer version but I still get the same error. I will have to keep digging on the internet to see how to fix it. If you come across anything let me know. my email is clint.carbaugh@figis.com
thanks Friedrich,
Clint
Quote:
Originally Posted by linder
Hello,
Because this problem is not related to the installation system (it's an Microsoft ODBC driver issue) I don’t know what it means, and I can only guess that it’s some kind dependency file (mfc42.dll???) problem.
See:
http://dbforums.com/showthread.php?threadid=504872
Does this help?
Re: setup a ODBC text file driver
Clint,
There are quite a few resources available with regards to the "The setup routines for XXX cannot be found" problem.
Perhaps you did not "self-register" some of the required dependency files? Or one or more dependency files are missing?
I really think the ODBC Text Driver manual can help here.