Cannot Connect To SQL Server From PHP Using The MS SQL Driver For PHP

Dec 3, 2007

Hey,

On a Vista Ultimate 64bit, SQL Server 2005 Developer Edition, IIS 7 & Zend Core 2.5, when running the following piece of code





Code Block

if (!extension_loaded('sqlsrv')) {
throw new Keops_Db_Adapter_Mssql_Exception('The sqlsrv extension is required for this adapter but not loaded');
}

$con = sqlsrv_connect('(local)');
Zend_Debug::dump($con);
Zend_Debug::dump(sqlsrv_errors());
Zend_Debug::dump(sqlsrv_warnings());

I get this in fcgi_strerr.log (the PHP error log)

02:11:01 03/12/07 : sqlsrv_connect: entering
handle_error: entered for function sqlsrv_connect
handle_errors_and_warnings: entering
SQLGetDiagRec returned 100
handle_errors_and_warnings: exitting

And the output of the page is
NULL
array(0) {
}
NULL

Any thoughts? I have Native Client Driver installed but I don't know if any additional configuration is necessary.
Thanks

View 7 Replies


ADVERTISEMENT

Issue Using The JDBC Driver To Connect To A Remote Server

Oct 25, 2006

Hi All,

We have a customer in Japan who's using our tool to connect to their SQL Server. Our application runs on a Linux machine and uses the MSSQL JDBC driver for connectivity.

We're getting errors back that are not-decipherable because, I presume, they're in Japanese, and then our logs don't log them in Unicode, so they get flattened out as question marks. The errors come out looking something like this:

Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]???? 'MSSQL'
???????????????????????????????

SQL State: HY000

SQL Code: 4060



[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]???? 'sa' ??????????????

SQL State: 28000

SQL Code: 18456



[Microsoft][SQLServer 2000 Driver for JDBC]An error occured while attempting to
log onto the database.

SQL State: 08001

SQL Code: 0

I think we could troubleshoot the problem if we could only read the errors coming back. I know in the ODBC world there are options like "Change the language of SQL Server system messages" and "Perform transaltion for character data" in the ODBC control panel. I couldn't find any similar options available in the JDBC driver however. Do they exist?

Even if they don't, just scanning the messages makes it pretty clear that there's an authentication/permissions issue at work here. We have another app using the same credentials that works fine though - so if there are any known issues about using JDBC to authenticate in a multi-lingual environment, that would be helpful too. Our tcpdumps seem to suggest that the JDBC driver is using multi-byte strings when communicating with the server, however the "working" application is using single-byte encoding. Could that be why we're not authenticating? How is that controlled? Note that at this point I'm just talking about authentication, not the codepages/encodings of the data in the database - right now I'm just worried about logging in.

Thanks!
Tom

View 3 Replies View Related

Query Analyzer Error Unable To Connect Server Local Msg17, Level 16,state 1/ODBC SQL Server Driver [DBNETLIB]SQL Server Does Not

Oct 20, 2007

I am getteing
need help
Query analyzer error Unable to connect server local Msg17, level 16,state 1
ODBC SQL server driver [DBNETLIB]SQL server does not exist

View 6 Replies View Related

Driver To Connect To Informix Via DTS??

Mar 1, 2004

Hi, folks!

I want to pump data from Informix to SQL Server using DTS to fill / fresh up my SQL-Server data warehouse every day.

In the SQL documentation I found "Don't use the ODBC driver from Informix"

Which is a good choice of ODBC/OLE-DB drivers to deal with Informix via SQL servers DTS?


Regards from Berlin!

SeBaFlu

View 3 Replies View Related

Connect To ODBC Driver

Feb 9, 2007

Could someone tell me how to use a query with a "connection string" to connect to an ODBC driver and retrieve data from its tables. I am new at this and have been having a lot of trouble connecting from the SSIS manager. If someone has a tutorial on how to do this. I would really appreciate it.

Thanks

View 3 Replies View Related

In Need Of Power Builder Driver To Connect To SQL 2K???

Mar 14, 2002

In need of Power Builder Driver to Connect to SQL 2K???

Any suggestions?

View 1 Replies View Related

Transact SQL :: Way To Configure ODBC Driver For Informix DB To Connect / Work With SSMS?

Aug 18, 2015

Basically, I am asking if it is possible to use SSMS (Query Analyzer window) with Informix.  I am thinking linked server.  If I have the ODBC driver installed on my workstation (win 7 pro VM workstation -- SSMS on same VM machine) is this doable? Do I just do the standard linked server routine or is there a special way (if it is even doable).

View 4 Replies View Related

Compatible Versions Of Ms SQL Server, ODBC Driver, Driver Manager And ODBC API Spec

Oct 28, 2004

Hi,

Please help share with me if you know the version compatibility matrix of Ms SQL Server, ODBC driver (sqlsrv32.dll), Driver Manager (odbc32.dll) and ODBC API spec. For instance, how can I know Ms SQL Server 2000 can work with which version of sqlsrv32.dll, a particular version of sqlsrv32.dll can work with which version of odbc32.dll and a certain version of sqlsrv32.dll/odbc32.dll conforms to which version of ODBC API spec (e.g. 3.5).

Any help will be appreciated.

Thanks,

vtluu.

View 1 Replies View Related

MS SQL Server JDBC Driver Type 2 And Driver Type 4 Differences

Jul 20, 2005

Hi,Could some please tell me whether Microsoft provides Type 2 and Type 4jdbc driver ? For Type 4 MS providescom.microsoft.jdbc.sqlserver.SQLServerDriver driver. What is thecofiguration required for type 2 driver and what driver class filesrequired ?Its very urgent to me please reply.Ajay

View 1 Replies View Related

[Microsoft][ODBC Driver Manager] Data Source Name Not Found And No Default Driver Specified

Oct 19, 2006

trying to install sql server2005 on a windows 2003 server box.

getting msg below at the sql server . i looked at other posts on trying to uninstall SQL Native Access Client and norton antivirus. i could never find the snac on the add - remove programs and this server does not have a virus protection program yet.

here's the history of the installs on the server:

wanted to test a 2005 upgrade so:

1) installed sql server 2000 then sp4 then restored some databases to it - all OK

2) tried to upgrade to sql 2005 but ran into problems and left it at that.

had a disk drive crash on the d drive so lost the installs but not the operating system

when the drive was replaced, left alone for a while

then wanted to test a straight 2005 install

1) removed the broken 2005 attempt

2) removed the 2000

3) installed 2005 and got the error on the subject line:

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

i've gone through as many of the forums that i can and have tried several things - like uninstalling 2005 and installing pieces and parts but but nothing seems to work.

Thanks!

Dan <><

View 17 Replies View Related

Sql2005 ODBC Driver Manager Data Source Name Not Found And No Default Driver Specified

Feb 4, 2008

i am attempting to run phpbb using ms sql 2005 on the same box but get the following error during the setup


Could not connect to the database, see error message below.
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


i am not sure yet if this is an issue with sql, php or phpbb

php is installed in iis and has all the modules installed which the php msi installer supported. i can run php code but in this case when i'm running the install.php file for the phphbb setup, i fill in the values for the database and got that error

phpbb detects all the required server settings and sees that i have ms sql installed

any suggestions on what that error means or how to go about configuring odbc driver?

probably a simple issue. but i'm still new with sql stuff

View 1 Replies View Related

Sybase Native Driver Vs Ole Db Driver

Oct 13, 2004

Hello,

I want to have a comparison about operation of a power builder application with sql server database, using sybase native driver and ole db driver.

View 2 Replies View Related

Cannot Connect W/ Java App But Can Connect W/ .Net App - SQL Server Express 2005

Dec 12, 2006

I'm having a problem connecting with a Java application but I CAN connect using my .Net application - the user name and password are the same for both (using the same database on SQL Server Express 2005).

The error I get is: "com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CORNERS" requested by the login. The login failed." An interesing note - I get the same message if the database is not running.

SQL Server Express 2005 is installed in mixed mode.

Here is my connection string in the .Net appplication: <add key="connectString" value="Server=(local);UID=sa;PWD=myPasswd;Database=CORNERS" />.

These are my values in my Java app web.xml -

<init-param>
<param-name>DBDriver</param-name>
<param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>
</init-param>
<init-param>
<param-name>DBURL</param-name> <param-value>jdbc:sqlserver://localhostsqlexpress:1055;databaseName=CORNERS</param-value>
</init-param>
<init-param>
<param-name>DBUser</param-name>
<param-value>sa</param-value>
</init-param>
<init-param>
<param-name>DBPwd</param-name>
<param-value>myPasswd</param-value>
</init-param>.

And yes, the port is 1055 - I checked to find it.

I am using Microsoft SQL Server 2005 JDBC Driver 1.0 (sqljdbc_1.0.809.102).

Does anyone have any idea what is wrong so that the login fails in the Java application but works in the .Net application?

View 7 Replies View Related

Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server Does Not Exist Or Access Denied

Jun 6, 2007

Hi,

When I am trying to access SQL Server 2000 database from another machine i got this error

Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied

but I could access the database on same server and in that server i could access other databases in different server.



View 6 Replies View Related

Help! SQL Server Error - [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid Object Name ...

Jul 23, 2005

Dear all,On Win2000 server with SP3, I am trying to access a SQL Server 7.0database, "TestDB", from VB6 via a SQL Server ODBC system DSN using ADO2.7. In SQL Server Enterprise Manager, there is a login named "Tester".In its property window, NO "Server Roles" was assigned but its"Database Access" was set to "TestDB". This login was also made as theuser of "TestDB" with "public", "db_datareader" and "db_datawriter"selected as its "Database role membership". All the tables I am tryingto access in "TestDB" were created under "Tester".My code is like:Set conn = New ADODB.Connectionconn.Open "DSN=TestDSN;UID=Tester;PWD=test"Set cmd = New ADODB.Commandcmd.ActiveConnection = conncmd.CommandText = SQLset rs = cmd.Execute()If I set the SQL to something like "SELECT * FROM tbl_test", I alwaysget an error of "-2147217865" saying "[Microsoft][ODBC SQL ServerDriver][SQL Server] Invalid object name tbl_test". If I set the SQL to"SELECT * FROM Tester.tbl_test", everything runs properly. Could anyoneplease kindly advise why the first SQL is not working? Or in otherwords, why must I prefix the table name with its owner while the DBconnection is already made under that owner name? Thanks in advance.Tracy

View 10 Replies View Related

SQL Server Driver

Apr 20, 2000

Does anyone know where the SQL Server Driver that is resided in the ODBC originally come from? Does it comes from the Operating Systems such as Windows 95?

I had that question because one of the user in my company could not connect to the database and got the error message saying "Unable to load communication module. Driver has not been correctly installed" after he shutted down his computer improperly.

Thanks in advance!

View 1 Replies View Related

[Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed For User 'ErrorLog'.

Feb 22, 2005

Hi, all

recently, I use the following script(somebody else) to create a database on a remote server: the script is as follow:
/*************************/
CREATE DATABASE [ErrorLog]
GO

Use ErrorLog

CREATE TABLE [dbo].[Errors] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[SessionID] [char] (12) NULL ,
[RequestMethod] [char] (5) NULL ,
[ServerPort] [char] (5) NULL ,
[HTTPS] [char] (3) NULL ,
[LocalAddr] [char] (15) NULL ,
[HostAddress] [char] (15) NULL ,
[UserAgent] [varchar] (255) NULL ,
[URL] [varchar] (400) NULL ,
[CustomerRefID] [varchar] (20) NULL ,
[FormData] [varchar] (2000),
[AllHTTP] [varchar] (2000),
[ErrASPCode] [char] (10) NULL ,
[ErrNumber] [char] (11) NULL ,
[ErrSource] [varchar] (255) NULL ,
[ErrCategory] [varchar] (50) NULL ,
[ErrFile] [varchar] (255) NULL ,
[ErrLine] [int] NULL ,
[ErrColumn] [int] NULL,
[ErrDescription] [varchar] (1000) NULL ,
[ErrAspDescription] [varchar] (1000) NULL ,
[InsertDate] [datetime] NOT NULL
) ON [PRIMARY]



--Create the user "ErrorLog"

if not exists (select * from master.dbo.syslogins where loginname = N'ErrorLog')
BEGIN
declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Navigator', @loginlang = N'us_english'
if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
select @logindb = N'master'
if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
select @loginlang = @@language
exec sp_addlogin N'ErrorLog', 'secret', @logindb, @loginlang
END
GO

if not exists (select * from dbo.sysusers where name = N'ErrorLog' and uid < 16382)
EXEC sp_grantdbaccess N'ErrorLog', N'ErrorLog'
GO

Grant select, insert On Errors to ErrorLog
/***************************/
in my *.asp program, I used the following string to connect to the database on the remote server.
/********
con.open "dsn=ErrorLog;uid=ErrorLog;pwd=secret;"
********/
the following message comes up:
/********/
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'ErrorLog'.
/*********/
what is the problem here?
when I set up dsn ErrorLOG, I used "abc" userID and password "XXX" which is our server database administrator assigned to me. I tested connection in odbc, it is OK
I just don't get, ther user ErrorLog already had login id and granted access to database errorlog. any clue, please help!
Betty

View 6 Replies View Related

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server Does Not Exist Or Access Deni

Sep 29, 2005

Hi..

when I use MSSQL in local ASP files , it is fine.

But If I try to connect another ASP file that is hosted by another machine, I get the following error!

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

in local I connect to my sql like below

Server=AAA*DDDDDDD

when I connect to mssql from another machine I try that

Server=IP/AAA*DDDDDDD
Server=IP

View 4 Replies View Related

ODBC Server Driver Shared Memory / Server Does Not Exist Or Access Denied

Nov 8, 2015

I am receiving the following error when starting a program called ShelbySystems that is supposed to connect to a local database. I don't think this is a security issue but I don't know much about SQL server either so...

  DIAG [08001] [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. (17)
  DIAG [01000] [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). (2)

System Info:
Windows 10 Home - upgrade from 8 64 bit
SQL server 2012 Express
SQL Backwards compatibility 2005 64 bit
ShelbySystems software v5.4

I am including the trace log in case it is useful.

DBInstall 130c-728ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x00000000
SQLHANDLE * 0x02EC58F4

[code]....

View 2 Replies View Related

1[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server Does Not Exist Or Access Denied.

Jul 26, 2007

Hi,

when I was sending 50 simultaneous connections to the web services, I got these 2 errors:
- "1[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. "

- "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)"


Everything worked fine if I ran 10 simultaneous connections. I am using Microsoft ACT to load test the web service. The database is SQL Server 2000. Any idea about why this is happening?

Appreciate your help! Thanks!

Jason Zhu

View 3 Replies View Related

[Microsoft][ODBC SQL Server Driver][SQL Server]'ISPALUSER' Is Not A Recognized Functi

May 25, 2006

When I try to export a database using DTS I get the following error message :

[Microsoft][ODBC SQL Server Driver][SQL Server]'ISPALUSER' is not a recognized function name.

Does anyone know what this means?

The database I am trying to export is a Publisher database being used to push replication data.

View 1 Replies View Related

ODBC SQL Server Driver TCP/IP Sockets SQL Server Does Not Exist Or Access Denied

Dec 3, 2004

I am running Windows 2003 Standard edition with IIS and SQL 2000 SP3a installed on it.

The web clients use ASP pages which use DSN to connect to SQL 2000 database. It has been working fine since last 1.5 years except 2 days ago when I faced this error suddenly on server:

In accessing any ASP page, it said:

[Microsoft][ODBC_SQL_Server_Driver][TCP/IP_Sockets_SQL_Server_does_not_exist_or_access_den ied.

On SQL Server error log, this was the entry at that time which I found:

SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]

The server (including SQL Server and agent service) were last stopped atleast a couple of days before, so it was not the problem about startup.

To troubleshoot, I restarted SQL Server and it worked for some time.

Then again on ASP pages, I found this error:

|80004005|[Microsoft][ODBC_SQL_Server_Driver][TCP/IP_Sockets]General_network_error._Check_your_network_document ation.

I checked the error logs of SQL server and didn't find anything.
Only entries were that the SQL is starting database, ports and IPs on which it is listening etc. The usual stuff. No errors in starting.

The SQL Agent log showed following errors:

2004-11-30 04:45:33 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2004-11-30 04:45:33 - ! [382] Logon to server '(local)' failed (JobManager)
2004-11-30 04:45:36 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE

I don't understand what was the problem. It first occured when nothing on server was changed, next it occured 30-32 hours later, and still now it hasn't happened again.

Does anyone know what can be wrong?

Thanks.

View 5 Replies View Related

[S0001][unixODBC][Easysoft][ODBC SQL Server Driver][SQL Server]Login Failed For User 'test1'

May 8, 2007

Hello,

I am new to SQL Server, sorry for my ignorance !!!

I have installed SQL Server 2005 Express on my desktop (Win 2000 Pro.)

I have created a new database.

I just created a new login/user (SQL Authentication) and when I try to login, it

errors out:

[S0001][unixODBC][Easysoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'test1'

I believe the error is from SQL Server and not from ODBC driver.

I am also only able to connect by using my own userid (the one that I am connected to my desktop): domainuserid, and then I am only able to connect to 'master' db:

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

/usr/local/etc>isql SQLSERVER_POS -v
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> use pcspos
[S0001][unixODBC][Easysoft][ODBC SQL Server Driver][SQL Server]Could not locate entry in sysdatabases for database 'pcspos'. No entry found with that name. Make sure that the name is entered correctly.
[ISQL]ERROR: Could not SQLExecute
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

View 11 Replies View Related

Can I Use SQL Server 2005 Driver For PHP On X64 2003 Server As 64bit Application?

Nov 21, 2007

I'm sorry to bother you.

Now I'm trying to run PHP web application on x64 2003 Server with Microsoft SQL Server 2005. The version of PHP is 5.2.3. and the web application should be run as 64bit applications. Since there seems no way to use php_mssql.dll on the environment, I'm trying to use SQL Server 2005 Driver for PHP but when PHP loads php_sqlsrv.dll, an error has occurd and there's a following message in an error log...

PHP Warning: PHP Startup: Unable to load dynamic library 'c:phpextphp_sqlsrv.dll' - %1 is not a valid Win32 application

From this message, I thought the distributed libraries for Windows would be for a Win32 environment but there seemed no information that says the libraries run on Win32 environment only.

I really appriciate if you help me.
Thank you.

View 4 Replies View Related

[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) Could Not Be Prepared.

Feb 1, 2007

I am using PowerDesigner to reverse engineer a SQL 2000 database. I am getting the following error. I can't find out what this error means. Does anyone know?

Unable to list the users. [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. SQLSTATE =37000

View 1 Replies View Related

I NEED THE JDBC DRIVER FOR MS SQL SERVER

Jan 18, 2001

please help it's urgent i badly need the jdbc driver for mssql for my project
thank u

View 1 Replies View Related

SQL Server ODBC Driver 3.6

Feb 8, 1999

In moving from odbc driver 2.65 to 3.6, we are getting a new error message.
'Unable to connect to data source xxxxx. Your user name or password may be incorrect.'
[Microsoft][ ODBC Driver Manager] Driver does not support this function. Has anyone else
had this problem? Thanks for any assistance. Karen Suenram

View 1 Replies View Related

Sql Server Jdbc Driver

Jan 18, 2005

Hi at all, i'm new here, your communitiy seems too much preparated.
My question is simple...
i must to connect via jdbc to a ms sql server 2000 database, but i'm in doubt to select which jdbc driver to use. your suggest over microsoft'drivers? i found on the internet the open source drivers jdts...what about them?

thank you and excuse for by bad english! :p

View 2 Replies View Related

Upgrade Of SQL Server Driver

Jul 23, 2005

Hi all,This might be a very stupid question: To do an upgrade of the SQL Serverdriver, would it be sufficient to just copy the latest version of theSQLSRV32.dll to the C:Windowssystem32 directory (overwriting the existentone). Or would I need to do more?Thanks in advance,BoB

View 1 Replies View Related

SQL Server 2005 Driver For PHP - Why?

Jan 29, 2008

Hello, I'm setting up a new PHP environment in Windows with IIS and this is the first I've seen of Microsoft's MS SQL driver for PHP. I'm debating on whether I should use this or the extension that PHP has included for many years. I'm just curious, why are they doing this? There must be some improvement over PHP's built in MS SQL functions, right? Performance Improvements? Functionality Improvements? Is this going to be a supported driver for many years (think PHP6 and beyond)?

Thanks!

View 1 Replies View Related

SQL Server 2005 Driver For PHP

Oct 16, 2007

I'm looking for shared web hosting with PHP, SQL Server 2005 and the SQL Server 2005 Driver for PHP. Know of any hosts?
Also, please share your experiences with this set up. I've programmed with VB.NET and ADO.NET accessing a SQL Server database, which has a rich set of data access objects. How does the SQL Server Driver for PHP compare for data access? How does it compare to the more traditional PHP/mySQL on Linux/Unix data access?

Thanks for your feedback, Michael

View 1 Replies View Related

Error String: [Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed For User '(null)'. Reason: Not Associated With A Trus

May 14, 2008



Hi all

This Job ran yester day fine,to day It got failed with this error

any suggestion to troubleshoot problem is appreciated.


DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147203052 (80044814)

Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Error source: Microsoft SQL-DMO (ODBC SQLState: 28000)

Help file: SQLDMO80.hlp

Help context: 1131



Error Detail Records:



Error: 0 (0); Provider Error: 0 (0)

Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Error source: Microsoft SQL-DMO (ODBC SQLState: 28000)

Help file: SQLDMO80.hlp

Help context: 1131



DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1

DTSRun: Package execution complete.

View 3 Replies View Related

[Microsoft][ODBC Server Driver][Sql Server] Blabla

Apr 14, 2008

I have an app developed in VB6. This calls some of sps in sql server.

Most of the times it behaves properly by NOT showing PRINT statements written in the stored procedure but some times it shows.

[Microsoft][ODBC Server Driver][Sql Server] 'blah blah'

'blah blah' is the message/text I print my stored procedure.

I don't know exact behavior that when PRINT in makes client apps calling will show it and when it won't show. May be I forgot


Note: These are the sps called both from GUI application and from query window. so I can't avoid using PRINT in these sps. I am using ADODB


Thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved