odbc-call failed

[19972003]

can anyone tell me why will I get this error when I try to run the report? I am trying to import the file to database and then it crashed "odbc-call failed"
SQl 2000/sp4
the user has the full permission to access the database when I click the database permission.

Many thanks,

 

[onpnt]

we need more details.

how are you importing the file?
what permissions does the user have?
is the file going into a new table or existing table?
have you tested the odbc?
have you used or tried better providers?


_{____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[19972003]

launch the application and click file import file xxx
user has the full acccess to the database from the server a to sql server box; verified the ODBC connection for that specific database, it connects fine also. THe file is going into existing tables.

also tried:
slices the file to small size and works the first time and the 2nd time failed with "odbc call failed"

 

[19972003]

anyone has any clues?

 

[19972003]

can you anyone tell me if I need to change my CPTIMeout on the sql or not please?

http://www.microsoft.com/technet/pr...ook/c07_odbc_connection_pooling.mspx?mfr=true

I load the application on my sql and run the report and still got the "odbc call failed" is my app faulty or the db itself or the configuration? it was working fine.
TIA

 

[fuzzyocelot]

What type of file is it? Excel, CSV, text? Could there be a data type mismatch?

Approximately how much data is in the file?

What kind of application are you using to import the file?

When you say the user has "full access to the database" which exact permissions are set (i.e. db_owner, db_datawriter, etc)?

 

[19972003]

thank you, the file type is csv and the file is about 44kb; I am using ms access 97 for the front end appliation and the backend is the sql 2000 database. user has the full db access "db_writer.

Thank You

 

[fuzzyocelot]

So if I understand what you're saying, you're trying to import the file into a SQL 2000 database table using MS Access 97? Is that right?

The SQL db_datawriter permission grants write privileges to the tables in the database. Full access would probably mean the user is an owner or a sysadmin, which it doesn't sound like it is. Not a big deal. The db_datawriter should be enough.

One thing I'd try is to make a local copy of the SQL table in Access and try to import the file into the local table to see what happens. Since you can import a small slice of it, I'm wondering if there is at least one record the table doesn't like. If that were true, though, then you should get a different error message.

Have you tried to import the file directly into the SQL tables using Enterprise Manager? That's something else I'd consider trying.

 

[19972003]

You are right, I will give a try and let you know.

Thank You,

 

[19972003]

Sorry it took me a while to get back to you, this is what happened, I installed the application and run the billing on the sQL server after the vendor modified a bunch fields in the table of the database and it seems processing fine and I didn't get any error messages. I also enabled the firewall log on sql server and found the server is dropping the connection, it there some utility out there I can use to check why the sql server dropping the connection from the client?

ODBC - Connection to 'SQL Server 10.5.2.8' failed

please help, this drives me insane.

Many thanks,

 

[fuzzyocelot]

I don't know if it would help or not, but you could try running a SQL trace to see what's happening on the SQL server side.