I am running sqlserve 2005 on window7 64bit and when i tried to access the database through an app, I get the error below.
SQLException caught = [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
What dose this mean
Error = [Microsoft][ODBC SQL Server Driver]ODBCBCP/Driver version mismatch
Hi.I'm trying to setup a publication but I received an error:The process could not bulk copy out of table 'cont20684C64E88B424BBBBE84921DEDFF77'.I used the log to get more specific info and I got the following:Microsoft SQL Server Snapshot Agent 8.00.760Copyright (c) 2000 Microsoft CorporationMicrosoft SQL Server Replication Agent: MyServer-MyMainDatabase-MyMainDatabase2MyTargetDatabase-4Connecting to Distributor 'MyServer'Connecting to Publisher 'MyServer.MyMainDatabase'Server: DBMS: Microsoft SQL ServerVersion: 08.00.0760user name: dboAPI conformance: 2SQL conformance: 1transaction capable: 2read only: Nidentifier quote char: "non_nullable_columns: 1owner usage: 31
max table name len: 128max column name len: 128need long data len: Ymax columns in table: 1024max columns in index: 16max char literal len: 524288max statement len: 524288max row size: 524288[8/3/2005 4:43:30 PM]MyServer.MyMainDatabase: sp_MSgetversionInitializing the publication 'MyMainDatabase2MyTargetDatabase'*** [Publication:'MyMainDatabase2MyTargetDatabase'] Publication view generation time: 201 (ms) ****** [Publication:'MyMainDatabase2MyTargetDatabase'] Make generation time: 100 (ms) ***Generating schema script for article '[ContactsCategories]'Generating conflict schema script for article '[ContactsCategories]'Generating referential integrity script for article '[ContactsCategories]'Generating trigger script for article '[ContactsCategories]'*** [Article:'ContactsCategories'] Time generating all schema scripts: 1762 (ms) ***Generating schema script for article '[Contacts]'Generating conflict schema script for article '[Contacts]'Generating referential integrity script for article '[Contacts]'Generating trigger script for article '[Contacts]'*** [Article:'Contacts'] Time generating all schema scripts: 1292 (ms) ****** [System table:'MSmerge_contents'] .SCH script generation time: 10 (ms) ***
*** [System table:'MSmerge_tombstone'] .SCH script generation time: 20 (ms) ***
*** [System table:'MSmerge_genhistory'] .SCH script generation time: 21 (ms) ***
*** [System table:'sysmergesubsetfilters'] .SCH script generation time: 30 (ms) ***
[8/3/2005 4:43:34 PM]MyServer.MyMainDatabase: select 1 from [dbo].[ContactsCategories] (TABLOCK HOLDLOCK) where 1=2 [8/3/2005 4:43:34 PM]MyServer.MyMainDatabase: select 1 from [dbo].[Contacts] (TABLOCK HOLDLOCK) where 1=2 Bulk copying snapshot data for system table 'MSmerge_contents'select * from cont20684C64E88B424BBBBE84921DEDFF77 where 1 = 2[8/3/2005 4:43:35 PM]MyServer.MyMainDatabase: select * from cont20684C64E88B424BBBBE84921DEDFF77 where 1 = 2SourceTypeId = 4SourceName = MyServerErrorCode = 0ErrorText = ODBCBCP/Driver version mismatchThe process could not bulk copy out of table 'cont20684C64E88B424BBBBE84921DEDFF77'.Disconnecting from Publisher 'MyServer'
I have also found in another forum tha this is related with the files sqlsrv32.dll, sqlsrv32.rll and odbcbcp.dll. The versions of these drivers in my server are:sqlsrv32.dll: 85.1025sqlsrv32.rll: 81.9001odbcbcp.dll: 81.9031Is it really the problem in the versions of these files? Anyone knows how to update them and if there any risks by doing it?Thanks in advance...
Thank you in advance for any advice that is provided from by the Dev Shed Users.
I'm on a development team that has been having an ongoing discussion/argument about the best way to handle our users needs while in Europe.
We are developing a Purchase Order application in VB.net using MSSQL Server 2000. We have about 5 out of 10 users that take a six-week trip to Europe. While in Europe the users will need to use the application. However, there are some cities they visit where the network connection will be slim to none.
The ongoing argument is as follows:
-Should we create a server running SQL Server 2000 for them to take Europe and sync up the two databases when they return?
-Should we create a version of the application running MS Access?
-Should we create a version of the application running MySQL?
-Should we do something completely different that we haven't thought of?
-Also, I'm not sure if the following is a possible architecture, from what I've found online I haven't seen an architecture that runs both SQL Server and Access (hope this makes sense):
Build the VB.net application running a shell of the database in Access (locally) that temporarily houses the data and tracks the database transactions made while using the system. Then upon closing the application a ?module? would execute that would perform the transactions made by the user on SQL Server. Then we could dump the SQL Server Database to an Access database before they go to Europe, and run their changes on the SQL Server Database when they return. Users at home will not be making changes to the same data as those in Europe.
Again any help would be greatly appreciated.
We have a Silverlight based application which currently supports only one production version. Idea is to support three concurrent versions of the same application and user will switch to the newer versions based on their interest or they can still continue with the older version.
We still have to use the existing database for all these three versions.
What is the best way to architect this so that we can differentiate the code between the versions and still keep the data in sync and run all the versions in parallel.
Which sort of data (from application architecture) point of view it's worth to put in XML datatype (MS SQL 2005)?
View 2 Replies View RelatedHi, all:My VC6 MFC application is recognized as a Unicode application by the drivermanager, so when I read nchar fileds in MS SQL Server database, theSQL_WCHAR does not convert to SQL_CHAR, and the application ASSERT failureat CRecordset::GetDefaultFieldType function.But I don't have "_UNICODE" defined, and have no "W" suffix functionscalled, and my old version program compiled on Feb 2004 just work fine.(source code lost unfortunatally)I read docs like:http://msdn.microsoft.com/library/d...ver_manager.asphttp://msdn.microsoft.com/library/d...ode_drivers.aspbut can't find the right answer.Could any one tell me how dow the driver manager judge the application to beUnicode aware?Best Regards,Qiang He(remove the "nospam." to email me, thanks)
View 1 Replies View RelatedI am developing an ETL system on a 32-bit machine let's say, called 'dwdev'. The application connects to a Sybase database as a source system using ODBC connection. I am able to run this application directly from Visual studio 2005 and i am able to deploy it into SQL Server 2005 and run it from Server as a job. Both work. At this server i am connecting to a SQL Server instance called 'dwdev'.
When i transfer my application onto a 64-bit machine, let's say called 'dwtest', i am able to run my application from Visual Studio 2005 properly and it works, but when i deploy it into SQL Server (instance is called 'dwtest') and try to run it as a job just like the development machine, it gives an error and stops executing.
I was facing 'data source' type of error when i was first trying it from Visual Studio, but i solved this problem by setting Run64bitRunTime settings to FALSE on the Project's properties Debugging Page, at 64-bit machine. now it uses 32-bit runtime then 32-bit Sybase ODBC driver. But i cannot force the application to use 32 bit runtime when i am executing it from SQL Server as a job.
How can i do that? is there an alternative method?
Thanks for your help...
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.
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 <><
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
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.
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.
I'm not sure why the numbers aren't being used as ints, all the examples I've found says this works...I appreciate any suggestions.products = trim(request.form("products")) response.Write("prods [" & products&"]") produces the output...prods [423,424,174] however, when i try and pass this to sql server 7 from asp, i get the following error (if i use query analyzer it works fine.)
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to int. cmd.Parameters.Append cmd.CreateParameter("@prods",adVarChar,adParamInput,255,products) conn.open cmd.ActiveConnection=conn cmd.Execute 'ERROR ON THIS LINE, SO HELPFUL!SP: @prods nvarchar(255) --paramSET @sql=@sql+' WHERE id in ('+@prods+')' --i've tried with the parens and without
Furniture table
fidint(11)
furniturenamevarchar(50)
companynamevarchar(30)
furnituredesignvarchar(30)
quantityvarchar(30)
colorvarchar(30)
Sizevarchar(30)
pricevarchar(30)
materialvarchar(30)
heightvarchar(30)
widthvarchar(30)
Sales table
Field
Type
salesidint(11)
fidint(11)
fsdatevarchar(10)
quantityint(11)
eidint(100)
employee table
Field
Type
eidint(100)
fnamechar(100)
lnamechar(100)
dobvarchar(100)
genderchar(100)
addressvarchar(100)
statuschar(100)
contactint(100)
emailidvarchar(100)
salaryint(100)
select f.furniturename as furniturename,f.quantity as tquantity,s.quantity as squantity,e.fname as fname,e.lname as lname from furnitures f inner join sales s inner join employee e on s.fid=f.fid and e.eid=s.eid";
furniture Name Total Quantity Sales quantity Remaining Quantity person
book rack 40 2 roshan shri
book rack 40 3 roshan shri
It displays 2 records , but it should display in 1 record.output should be like this
bookrack 40 5 35 roshan shri
I am retrieving data from an AS400. I used the import data utility to pull the data in initially and to create the table for the data in SQL server. There are a couple of text fields that represent dates in the data I imported.
The Import data utility imported these fields as character data. That was fine by me.
Now, when I pull new data from the same AS400 data source I have to use the Data Reader source (due to the OLEDB components not being able to work with an SQL command;i,e, it works okay when pulling the entire table but does not work at all with even the simplest of sql statements). The data reader source insists on interpreting the text fields containing date data from the AS400 as DB_DATETIMESTAMP data type. The net effect of this is that the data it pulls in in the DB_DATETIMESTAMP format is too large to fit into the 10 character varchar field that was created when the entire table was imported.
I know I can get around this in a couple of ways. But, my question is this. Why will the DateReader source not let me specify how I want the incoming data to be interpreted? There seems to be no way to change the way the external column is interpreted. By this I mean that I can change the external columns representation on the datareader source to indicate that I want it treated as a 10 character text field but I cannot change the output column representation. When I try to do so I get an error message telling me the data type of the output columns on the component datareader source cannot be changed. It seems a bit odd to me that character data coming in cannot be treated as character data in output.
It looks like I will need to use a script component to force the data conversion that I want and it just doesn't make a lot of sense to me as to why I can't do what I need to do in a conversion component.
I would feel better if I could understand what is going on behind the scenes that makes this state of affairs desirable.
Thanks in advance.
Hello,
I want to kow if the following architecture is good :
Disque 1&2 ( Raid 1)
c: OS
d: sqlserver + system tables + log files
Disque 3&4&5 (Raid 5)
e: data
Hi,
Someone can tell me if the following architecture is good :
f:master db
g:soft db + log
where can we get to know the architecture of sqlserver 2005
View 4 Replies View RelatedServer: Msg 8908, Level 22, State 6,
on index defragmentation on a table.
Table error: Database ID 490, object ID 517576882, index ID 0. Chain linkage mismatch. (1:13020)->next = (1:13021), but (1:13021)->prev = (1:13080).
from error.log found corresponding error on dbcc checkdatabase on this same database:
I/O error (bad page ID) detected during read at offset 0x00000006614000 in file
'T:DataABCABC_data.mdf'..
Waiting for type 0x4, current count 0x100022, current owning EC 0x76A85540.
Error: 823, Severity: 24, State: 2
is there a way to fix this chain linkage mismatch error?
thanks
-D
I am new to SQL.
I have the following SQL query.
Update TimeSheet SET TotalTime=TimeOut - TimeIn;
The data type for TotalTime required by me is (For example)
2 Days 3 Hrs.
So what should is Do?
At present i am getting output as 'Jan 1 1900 1:00AM' where as i want it to show as 0 days 1 hour.
I've changed the width of a column from 128 to 64. How to EM shows 64, while sysobjects and sp_help show 128 ?? Even after disconnecting and re-connecting (just to be extra sure).
View 2 Replies View RelatedI have been throwing these lovely errors on my db (approx 16Gb) all of a sudden - they might all be related:
1) Operations Manager Critical Error Alert
Severity: Critical Error
Status: New
Source: MSSQLSERVER
Name: Attempt to fetch logical page belongs to different object .
Description: Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (4:1878339) in database 'NGProd' belongs to object 'claim_requests', not to object 'Assessment_'.
2) Event Description:
Error: 644, Severity: 21, State: 5
Could not find the index entry for RID '36303030318eefd3713d52f4a85df3b0b8a889904e4e608102703230303530393139'
in index page (3:271543), index ID 9, database 'NGProd'.
3) Event Description:
Error: 8908, Severity: 22, State: 6
Table error: Database ID 10, object ID 86095893, index ID 0. Chain linkage mismatch. (4:1880687)->next = (4:441596), but (4:441596)->prev = (4:441595)
dbcc checkdb gives me 0 errors & running the built-in integrity reports does not seem to find anything.
I have been told that my db has "cracks" in it, and that I need to export ALL of it and then re-import. Seems a bit too much work...
Anyone have any ideas on what I should first attempt to do? I don't even know how to fix these errors... seems that I only throw then when users are accessing specific records.
Any help would be most welcome!
Thanks,
k
I have a problem using 3 tables. The first recordset is my own invention (that means a very simple one). It reads product features from a table:
Set Rsx = Server.CreateObject("ADODB.RecordSet")
sSQL= "SELECT * from prodfeatures"
Rsx.Open sSQL, sDSN, adOpenStatic, adLockReadOnly, adCmdText
'then I read the recordset into arrays like this:
While Not Rsx.eof
i=i+1
mte(i)=Rsx("id")
' every id has a corresponding featurename
mfnavn(mte(i))=Rsx("featurename")
Rsx.movenext
Wend
'this part works very well
Now comes the difficult part that the SQLTeam figured out (this combines an order base with an itemorder base):
Set Rs = Server.CreateObject("ADODB.RecordSet")
sSQL="select oitems.catalogid,oitems.features, sum(oitems.numitems) as SumOfItems from oitems Inner Join Orders On Orders.orderid = oitems.orderid Where Orders.oshippeddate =" & dDate & " AND Orders.orderid <> 1 group by oitems.catalogid,oitems.features"
Rs.Open sSQL, sDSN, adOpenStatic, adLockReadOnly, adCmdText
'Then I write the content of the products with product features - the complexity of the sql is due to a use of many other operations:
While Not Rs.eof
response.write Rs("catalogid") & "features:" & Rs("features") & "Name:" & mfnavn(rs("features"))
Rs.movenext
Wend
The query runs, and starts well, writing 3 lines:
239 features:221 Name:Standard bil max 5m lang og 1,9 m høy
240 features:270 Name:Liggestol (gratis)
240 features:271 Name:C1 Enkeltseng i delt lugar u. bildekk. Kun vask
but it is then aborted with this message:
Microsoft VBScript runtime error '800a000d' Type mismatch: 'Rs(...)'
I know that the problematic part is the array
mfnavn(rs("features"))
...anyone with experience in this?
HelloMY SQL Server is causing me this problem :Microsoft VBScript runtime error '800a000d'Type mismatch: 'ident'[color=blue][color=green][color=darkred]>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>[/color][/color][/color]I am getting from the table datingnew the value of the ident field."select max(ident)as test from datingnew"ident = RS2("test")ident = ident + 1The ident value is passed over 2 sites by hidden form value. There I amsimpy trying to insert it again in the same table datingnew.[color=blue][color=green][color=darkred]>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>[/color][/color][/color]query = "INSERT INTO datingnew(ident,....,registerdate)"query = query & " VALUES ('" & ident & "', '" & .... & "', '" ®isterdate & "')"there the error message is comeing each time :[color=blue][color=green][color=darkred]>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>[/color][/color][/color]Microsoft VBScript runtime error '800a000d'Type mismatch: 'ident'[color=blue][color=green][color=darkred]>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>[/color][/color][/color]I have tried to change the the type of ident in the table datingnew tointeger , nvarchar, ....Tried to close the recordset each time with db.close, RS. close.Changed the ident field to standard, but also to with and withoutduplication, didnt help so far ...Need helpkind regards ArunMicrosoft VBScript runtime error '800a000d'Type mismatch: 'ident'
View 5 Replies View RelatedGetting this error after installing certificate. Happens when trying to access https://machinename/reports
Possible SOAP version mismatch: Envelope namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting http://schemas.xmlsoap.org/soap/envelope/. SQL Server Reporting Services 2005 on Windows Server 2003 R2.
Was working fine before adding the certificate.
Any thougts on how to fix?
Thanks in advance,
Dan
I am exporting my sql table to the access database. My text fileds in SQL are stored as varchar(50) in SQL server 2005. but when I export the table to Access, These fileds get converted to 'memo' fields. I tried converting these memo fields in access to text field but Access does do that, throws an error message saying not enough disk space.
When I try to convert these 'varchar' fields in sql to text fileds, sql throws a 'time out ' message nad does not convert it to text.
What do I do??
Thanks
Hi all,
my package has a lot of lookups of fact table fields against dimension tables.
i did a redirect row for each lookup error to a flat file.
i wanted to put all lookup mismatch on the same file, but i couldn't do it because there'll be error saying that
The process cannot access the file because it is being used by another process.
i don't think it's practical to have flat files for each lookups. how is this normally done? please help...
thanks!
Hi,
I am developing an application to mail the Newsletters on a daily basis with Service Broker . I have a peculiar problem, that the queues associated with same dialog is giving different conversation handles. I'm testing the application with one mail at a time, i.e., there are not more than one item in both the queue at one point of time. But the handles returned by the queues are different within the same conversation.
Why it is happening like that ? I have taken backup of the original database and restored with a different name in the same instance (and will run "ALTER DATABASE db_name SET NEW_BROKER" for the new database) for some purpose. Can it cause problem ?
Please help.
Thanks in advance.
Regards
Babu
We have database thats transaction intensive, so we are trying to sepetrare ldf file from mdf file to a different disk array. what raid should I use for the Transactional log file(.ldf).
Thank You,
John
I would like to know where I can find a senior database architect. Someone who can develop
and implement the database and its stored procedures. I am looking for an experienced person.
It is a contract position, in San Franicisco. The pay is good. Could anyone help me?
I tried Dice, Monster and it seems all of you are working...
I am replacing the corporate SQL Server at work. The new server will have 6 striped disks of 160G with about 4G of RAM. The current SQL Server currently has two instances which run web applications and a small database warehouse about 6G. Analysis Services is also installed.
Due to a couple of new apps being added to the server and the SQL Server 2000 enterprise license we acquired, i was thinking of adding 2 more instances so that the applications can be independently managed in terms of restarting the SQL Server. I also would like to permanently fix the memory settings on each instance to give more resources to more important applications. The log and data files would also be spilt onto 2 separate hard disks. i understand there are implications on performance such as CPU etc. Is it normally advisable to have more than 1 or 2 instances ? Most of the applications are not very CPU intensive. What other implications or performance issues would l have ?
We will be creating a moderately high-volume OLTP database application that needs 24/7 availability. We are planning to offload OLAP processing to a second copy of the system. We will be using SQL Server 2005.
I originally planned to set the second server up with SQL Server 2005 mirroring to cover the 24/7 availability requirement, with the idea that we could also do OLAP reporting off of the mirrored copy of the database. But I've gotten some indications that a mirror database is offline and not available for querying. So I figured I would use transactional replication to keep the OLAP database current. Now I am wondering if I need to use mirroring at all, or if I should just use transactional replication on the entire database and swap to the replicated database if the production server crashes.
What is everyone's opinion?
Replication only, for both OLAP reporting and failover?
Mirroring to one database for failover, with replication to a another database for OLAP reporting?