Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Opo
Starting Member
2 Posts |
 Posted - 2004-08-18 : 11:38:32
|
| HelloExcuse me, I don't speak English well but I have a trouble with a command "BULK INSERT" into a modul VBA (Access 2000)I execute the command :Set connSQLServer = wsODBC.OpenConnection(gsODBCDSN, dbDriverCompleteRequired, False, sConnectODBC)connSQLServer.QueryTimeout = 0sSQL = Exec qry_Import_Fichier 'IP001U1P','d:\Projets\Playtex\Test Import\IP001U1P.TXT','d:\Projets\Playtex\Test Import\IP001U1P.fmt'connSQLServer.Execute sSQLI have the error : 3146 ODBC -- l'appel a échoué.With "Analyseur de requetes" from SQL Server 2000, the command is OK !Does anybody have an idea ?ThanksMarie-Pierre |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-08-18 : 12:53:58
|
| Depends on what qry_Import_Fichier is doing but maybe the user doesn't have permission on the file.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Opo
Starting Member
2 Posts |
Posted - 2004-08-19 : 05:33:52
|
| Right !!It was a problem with the user's profil !!!Thanks a lot !Marie-Pierre |
|
|
|
|
|
|
BULK INSERT + error ODBC