SQL failed. Error: [12] [1] [0] "[ProvideX][ODBC Driver][FILEIO]Table

[maicap22]

Can someone tell me how to get around this one. I am a programmer for a certain client who works through remote server. So I am connected to the main server and the MAS 90 folder is on their server 3. Connection to the DSN is already okay. Just this one again. I've been browsing forums about this so I got the idea that it may be caused by permission restrictions. But I am not used on tampering permissions in IIS environment.

 

[maicap22]

by the wa,im using perl script for database connection and data retrieval from mas 90

script goes like:
my $DSN = "DSN=SOTAMAS90;Company=company;UID=userid;PWD=password";
my $db = new Win32::ODBC($DSN);

 

[dfeller]

It appears that you are missing the data path.

Dawn

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[BigLouie]

DSN=SOTAMAS90;Company=company;UID=userid;PWD=password;Directory=Z:\MAS90;SERVER=NotTheServer

Also you should be posting on the Sage Community. Follow the link in Dawn's response. You will receive faster and more responses.